/*
 Navicat Premium Data Transfer

 Source Server         : 腾讯云
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 124.221.213.179:3309
 Source Schema         : flask_new

 Target Server Type    : MySQL
 Target Server Version : 50650
 File Encoding         : 65001

 Date: 16/05/2022 10:18:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_admin_log`;
CREATE TABLE `admin_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `method` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `desc` text COLLATE utf8_unicode_ci,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8_unicode_ci,
  `create_time` datetime DEFAULT NULL,
  `success` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1556 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_admin_log` VALUES (1485, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-27 08:01:14', 1);
INSERT INTO `admin_admin_log` VALUES (1486, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-27 11:09:22', 1);
INSERT INTO `admin_admin_log` VALUES (1487, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-27 15:35:33', 1);
INSERT INTO `admin_admin_log` VALUES (1488, 'POST', 1, '/passport/login', 'admin', '100.88.22.128', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-03-27 21:28:55', 1);
INSERT INTO `admin_admin_log` VALUES (1489, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-27 21:34:26', 1);
INSERT INTO `admin_admin_log` VALUES (1490, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-28 12:02:22', 1);
INSERT INTO `admin_admin_log` VALUES (1491, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-28 21:02:45', 1);
INSERT INTO `admin_admin_log` VALUES (1492, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-03-29 13:42:11', 1);
INSERT INTO `admin_admin_log` VALUES (1493, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-29 13:43:32', 1);
INSERT INTO `admin_admin_log` VALUES (1494, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-30 13:56:33', 1);
INSERT INTO `admin_admin_log` VALUES (1495, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-31 11:29:01', 1);
INSERT INTO `admin_admin_log` VALUES (1496, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-03-31 14:29:22', 1);
INSERT INTO `admin_admin_log` VALUES (1497, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-01 22:37:12', 1);
INSERT INTO `admin_admin_log` VALUES (1498, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-04-04 16:34:51', 1);
INSERT INTO `admin_admin_log` VALUES (1499, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 09:43:13', 1);
INSERT INTO `admin_admin_log` VALUES (1500, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 12:44:06', 1);
INSERT INTO `admin_admin_log` VALUES (1501, 'POST', 7, '/passport/login', 'test', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 15:16:45', 0);
INSERT INTO `admin_admin_log` VALUES (1502, 'POST', 7, '/passport/login', 'test', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 15:16:56', 1);
INSERT INTO `admin_admin_log` VALUES (1503, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 15:17:24', 1);
INSERT INTO `admin_admin_log` VALUES (1504, 'POST', 7, '/passport/login', 'test', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-04-05 15:45:35', 1);
INSERT INTO `admin_admin_log` VALUES (1505, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36', '2022-04-05 19:14:50', 1);
INSERT INTO `admin_admin_log` VALUES (1506, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-07 21:57:57', 1);
INSERT INTO `admin_admin_log` VALUES (1507, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-10 16:09:11', 1);
INSERT INTO `admin_admin_log` VALUES (1508, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-12 15:46:53', 1);
INSERT INTO `admin_admin_log` VALUES (1509, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-14 10:00:18', 1);
INSERT INTO `admin_admin_log` VALUES (1510, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36', '2022-04-14 23:52:12', 1);
INSERT INTO `admin_admin_log` VALUES (1511, 'POST', 1, '/passport/login', 'admin', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 11:23:09', 1);
INSERT INTO `admin_admin_log` VALUES (1512, 'POST', 1, '/passport/login', 'admin', '58.19.86.24', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 11:53:00', 1);
INSERT INTO `admin_admin_log` VALUES (1513, 'POST', 1, '/passport/login', 'admin', '58.19.86.24', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 11:54:03', 1);
INSERT INTO `admin_admin_log` VALUES (1514, 'POST', 1, '/passport/login', 'admin', '58.19.86.24', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 16:37:28', 1);
INSERT INTO `admin_admin_log` VALUES (1515, 'POST', 1, '/passport/login', 'admin', '117.63.200.179', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 19:52:56', 0);
INSERT INTO `admin_admin_log` VALUES (1516, 'POST', 1, '/passport/login', 'admin', '117.63.200.179', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 19:53:05', 0);
INSERT INTO `admin_admin_log` VALUES (1517, 'POST', 1, '/passport/login', 'admin', '117.63.200.179', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.88 Safari/537.36', '2022-04-15 19:59:41', 0);
INSERT INTO `admin_admin_log` VALUES (1518, 'POST', 1, '/passport/login', 'admin', '58.19.87.68', 'Mozilla/5.0 (Linux; Android 10; HarmonyOS; MRX-W29; HMSCore 6.4.0.312) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.105 HuaweiBrowser/12.0.5.302 Safari/537.36', '2022-04-16 14:25:06', 1);
INSERT INTO `admin_admin_log` VALUES (1519, 'POST', 1, '/passport/login', 'admin', '191.101.132.139', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-20 14:15:33', 0);
INSERT INTO `admin_admin_log` VALUES (1520, 'POST', 1, '/passport/login', 'admin', '58.19.86.12', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-04-20 21:43:04', 0);
INSERT INTO `admin_admin_log` VALUES (1521, 'POST', 1, '/passport/login', 'admin', '58.19.86.208', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-23 11:18:49', 1);
INSERT INTO `admin_admin_log` VALUES (1522, 'POST', 1, '/passport/login', 'admin', '58.19.86.221', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-25 19:11:52', 0);
INSERT INTO `admin_admin_log` VALUES (1523, 'POST', 1, '/passport/login', 'admin', '58.19.86.221', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-25 19:12:03', 0);
INSERT INTO `admin_admin_log` VALUES (1524, 'POST', 1, '/passport/login', 'admin', '58.19.86.221', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-25 19:12:15', 1);
INSERT INTO `admin_admin_log` VALUES (1525, 'POST', 1, '/passport/login', 'admin', '58.19.86.122', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-26 09:24:44', 1);
INSERT INTO `admin_admin_log` VALUES (1526, 'POST', 1, '/passport/login', 'admin', '58.19.86.122', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-26 10:04:21', 1);
INSERT INTO `admin_admin_log` VALUES (1527, 'POST', 1, '/passport/login', 'admin', '58.19.87.101', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-29 12:23:36', 0);
INSERT INTO `admin_admin_log` VALUES (1528, 'POST', 1, '/passport/login', 'admin', '58.19.87.101', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-29 12:23:54', 1);
INSERT INTO `admin_admin_log` VALUES (1529, 'POST', 1, '/passport/login', 'admin', '49.80.75.196', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36', '2022-04-30 00:48:32', 0);
INSERT INTO `admin_admin_log` VALUES (1530, 'POST', 1, '/passport/login', 'admin', '101.88.3.148', 'Mozilla/5.0 (Linux; Android 11; Redmi K30 Pro Zoom Edition Build/RKQ1.200826.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/90.0.4430.210 Mobile Safari/537.36 BossZhipin/9.100/1003 /zci/hsAekArqMVtk7JCYNcRdct8i3vGskyjS8a03DU6KPvE-rNln9-qnmQIqalDEEdkP-nfj1dDCNmTA86_siekd9pYV07XhB42VwvKLVsHL7EvY0YAxNSQ8P21c_XPDIbyOYBho3sGshLrp-S9Jq3E75pyDlVvKwZOfLY82NVX16CYOfdxltayVVIxLtkHgaBeBnDPUScesJD_6xMKxtdDQNWShgvYxRq93UBNuMR-elqxnqdRMxNGCAwMPRUv1SJFZ_Ttm6kFHvCtnsKp0rBqYLunPblvE_zxPUjF4m_DATF59R5-TQM1YzEyaEPyQe8LPN6mXgrcRBN7Y87fHE88z886BFGQCIBzvIFNsMXqgM2aHGBlvcc2F8nKGt5sN3DYbQrDXumHilbosbpGbQxYsOB3syEIaTYozUTyDL2BdPbgn31SGxEQQyB3rf1_GViUi_WXDLjpyNjHf7MFOYV0mf79YawXBJisYLXpDkoSzBC3OE5A7ZwbiffLsm9-lxsghQ1rp7ltgbbgumivap12I3L_vteuTruMm3eB6W4A_MtjVQcfHLHbaOmRfn5MG2BFcjQa6FwDqBwrkPkvoo73xlIg0iZZCcrGub7y-RHJhzbZBFcY4bxwibfFmWxiHyn2xgcbQ31Z1kpXWVgJxVvpD10qTQpiSTotZkgFEhQrR7q8QTkA~', '2022-04-30 12:41:36', 0);
INSERT INTO `admin_admin_log` VALUES (1531, 'POST', 1, '/passport/login', 'admin', '101.88.3.148', 'Mozilla/5.0 (Linux; Android 11; Redmi K30 Pro Zoom Edition Build/RKQ1.200826.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/90.0.4430.210 Mobile Safari/537.36 BossZhipin/9.100/1003 /zci/hsAekArqMVtk7JCYNcRdct8i3vGskyjS8a03DU6KPvE-rNln9-qnmQIqalDEEdkP-nfj1dDCNmTA86_siekd9pYV07XhB42VwvKLVsHL7EvY0YAxNSQ8P21c_XPDIbyOYBho3sGshLrp-S9Jq3E75pyDlVvKwZOfLY82NVX16CYOfdxltayVVIxLtkHgaBeBnDPUScesJD_6xMKxtdDQNWShgvYxRq93UBNuMR-elqxnqdRMxNGCAwMPRUv1SJFZ_Ttm6kFHvCtnsKp0rBqYLunPblvE_zxPUjF4m_DATF59R5-TQM1YzEyaEPyQe8LPN6mXgrcRBN7Y87fHE88z886BFGQCIBzvIFNsMXqgM2aHGBlvcc2F8nKGt5sN3DYbQrDXumHilbosbpGbQxYsOB3syEIaTYozUTyDL2BdPbgn31SGxEQQyB3rf1_GViUi_WXDLjpyNjHf7MFOYV0mf79YawXBJisYLXpDkoSzBC3OE5A7ZwbiffLsm9-lxsghQ1rp7ltgbbgumivap12I3L_vteuTruMm3eB6W4A_MtjVQcfHLHbaOmRfn5MG2BFcjQa6FwDqBwrkPkvoo73xlIg0iZZCcrGub7y-RHJhzbZBFcY4bxwibfFmWxiHyn2xgcbQ31Z1kpXWVgJxVvpD10qTQpiSTotZkgFEhQrR7q8QTkA~', '2022-04-30 12:41:51', 0);
INSERT INTO `admin_admin_log` VALUES (1532, 'POST', 1, '/passport/login', 'admin', '61.242.134.12', 'Mozilla/5.0 (Linux; Android 10; WLZ-AN00 Build/HUAWEIWLZ-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/89.0.4389.72 MQQBrowser/6.2 TBS/045947 Mobile Safari/537.36 BossZhipin/10.030/1003 /zci/5BGY7zOruCcHIxZXdCJUbKdjWZG_8kB8np3uDsxYr0Vm4irZEqyOjmtWMYEQr71j_e6YUle0oDtHPjjET3JgsZbmt7L4udVH--7J_SXKY8idoLeb6PSAbg39WOw_8hyQQaduHU9hn7J2QQuZOK49ElRKHDApGb7l2cSOusssIRUJ-VJXfNwF5LV3AV_wNQHabA4871VwHsJS1S_oE_7Ofhe12wuUSXuc3d_djtH968voCAQgBuWJeqaFIpmfHScXEso8vd6lBsFK6Ovp-p_wvMucEBmnmENpv244Rd-LUNK4kYZwoqfyl4A2iX6LFoujdk61LpbpTcdWSsNgLzx3iJex2roLFiIn03_SgwTSOq9ts7_hkiYLBAEV8pTudrBrz-bxzcPfcW_8AXNOaNiyIUXa_Yob3IYmCAEY6_SlPlGtHxvO31yzrIgYZFP9ehr4j5Prt-WbrRZX1Kv-H056AffGI6-Izra1bsmj4pMRbKqy9qC0MBw5eGnUL_BcbbLDONuuRpdl_ezSLgAwEHHmX73zR5XC2FsalsRvQrowjx8_q3BEQBSOKZZNquSeVXQ7CmqWwOZx3pwmabC4mmdL4vbsYYAkcXd-SugbsJSqgbLhODeKj3PG3bJq9Q~~', '2022-04-30 12:43:13', 1);
INSERT INTO `admin_admin_log` VALUES (1533, 'POST', 1, '/passport/login', 'admin', '58.19.86.45', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-04-30 13:55:00', 1);
INSERT INTO `admin_admin_log` VALUES (1534, 'POST', 1, '/passport/login', 'admin', '58.19.87.181', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-05-03 11:28:47', 1);
INSERT INTO `admin_admin_log` VALUES (1535, 'POST', 1, '/passport/login', 'admin', '58.19.87.200', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-05-03 21:43:10', 1);
INSERT INTO `admin_admin_log` VALUES (1536, 'POST', 7, '/passport/login', 'test', '58.19.87.200', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36', '2022-05-03 21:44:22', 1);
INSERT INTO `admin_admin_log` VALUES (1537, 'POST', 1, '/passport/login', 'admin', '58.19.86.46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-06 14:25:04', 1);
INSERT INTO `admin_admin_log` VALUES (1538, 'POST', 7, '/passport/login', 'test', '58.19.87.44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-08 11:03:40', 1);
INSERT INTO `admin_admin_log` VALUES (1539, 'POST', 1, '/passport/login', 'admin', '58.19.87.44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-08 21:40:28', 1);
INSERT INTO `admin_admin_log` VALUES (1540, 'POST', 7, '/passport/login', 'test', '58.19.86.236', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-09 21:06:33', 1);
INSERT INTO `admin_admin_log` VALUES (1541, 'POST', 7, '/passport/login', 'test', '58.19.86.236', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-10 00:13:02', 1);
INSERT INTO `admin_admin_log` VALUES (1542, 'POST', 1, '/passport/login', 'admin', '58.19.86.31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-10 12:15:14', 1);
INSERT INTO `admin_admin_log` VALUES (1543, 'POST', 7, '/passport/login', 'test', '58.19.86.31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-10 12:38:54', 1);
INSERT INTO `admin_admin_log` VALUES (1544, 'POST', 1, '/passport/login', 'admin', '58.19.86.31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-10 12:39:14', 1);
INSERT INTO `admin_admin_log` VALUES (1545, 'POST', 1, '/passport/login', 'admin', '58.19.86.207', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36', '2022-05-10 20:39:33', 1);
INSERT INTO `admin_admin_log` VALUES (1546, 'POST', 1, '/passport/login', 'admin', '61.242.134.175', 'Mozilla/5.0 (Linux; Android 10; WLZ-AN00 Build/HUAWEIWLZ-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/76.0.3809.89 Mobile Safari/537.36 T7/13.7 BDOS/1.0 (HarmonyOS 2.2.0) SP-engine/2.45.0 baiduboxapp/13.7.0.12 (Baidu; P1 10) NABar/1.0', '2022-05-11 07:42:43', 0);
INSERT INTO `admin_admin_log` VALUES (1547, 'POST', 7, '/passport/login', 'test', '58.19.87.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 08:22:19', 1);
INSERT INTO `admin_admin_log` VALUES (1548, 'POST', 1, '/passport/login', 'admin', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 10:17:08', 1);
INSERT INTO `admin_admin_log` VALUES (1549, 'POST', 7, '/passport/login', 'test', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 10:18:09', 1);
INSERT INTO `admin_admin_log` VALUES (1550, 'POST', 1, '/passport/login', 'admin', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 10:18:28', 1);
INSERT INTO `admin_admin_log` VALUES (1551, 'POST', 1, '/passport/login', 'admin', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15', '2022-05-11 10:20:18', 1);
INSERT INTO `admin_admin_log` VALUES (1552, 'POST', 7, '/passport/login', 'test', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 10:36:13', 1);
INSERT INTO `admin_admin_log` VALUES (1553, 'POST', 7, '/passport/login', 'test', '58.19.86.209', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-11 11:39:26', 1);
INSERT INTO `admin_admin_log` VALUES (1554, 'POST', 1, '/passport/login', 'admin', '61.242.134.175', 'Mozilla/5.0 (Linux; Android 10; WLZ-AN00 Build/HUAWEIWLZ-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/76.0.3809.89 Mobile Safari/537.36 T7/13.7 BDOS/1.0 (HarmonyOS 2.2.0) SP-engine/2.45.0 baiduboxapp/13.7.0.12 (Baidu; P1 10) NABar/1.0', '2022-05-11 15:11:40', 1);
INSERT INTO `admin_admin_log` VALUES (1555, 'POST', 1, '/passport/login', 'admin', '61.242.135.17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36', '2022-05-14 08:47:20', 1);
COMMIT;

-- ----------------------------
-- Table structure for admin_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `admin_dict_data`;
CREATE TABLE `admin_dict_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型名称',
  `data_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型标识',
  `type_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型描述',
  `is_default` int(11) DEFAULT NULL COMMENT '是否默认',
  `enable` int(11) DEFAULT NULL COMMENT '是否开启',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `admin_dict_data` VALUES (8, '男', 'boy', 'user_sex', NULL, 1, '男 : body', '2021-04-16 13:36:34', '2021-04-16 14:05:06');
INSERT INTO `admin_dict_data` VALUES (9, '女', 'girl', 'user_sex', NULL, 1, '女 : girl', '2021-04-16 13:36:55', '2021-04-16 13:36:55');
COMMIT;

-- ----------------------------
-- Table structure for admin_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `admin_dict_type`;
CREATE TABLE `admin_dict_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型名称',
  `type_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型标识',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典类型描述',
  `enable` int(11) DEFAULT NULL COMMENT '是否开启',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `admin_dict_type` VALUES (1, '用户性别', 'user_sex', '用户性别', 1, NULL, '2021-04-16 13:37:11');
COMMIT;

-- ----------------------------
-- Table structure for admin_photo
-- ----------------------------
DROP TABLE IF EXISTS `admin_photo`;
CREATE TABLE `admin_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `href` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mime` char(50) COLLATE utf8_unicode_ci NOT NULL,
  `size` char(30) COLLATE utf8_unicode_ci NOT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_photo
-- ----------------------------
BEGIN;
INSERT INTO `admin_photo` VALUES (19, 'mypic.jpg', '/_uploads/photos/mypic.jpg', 'image/jpeg', '37721', '2022-04-05 16:46:36');
INSERT INTO `admin_photo` VALUES (23, '1649994811000.jpg', '/_uploads/photos/1649994811000.jpg', 'image/png', '140780', '2022-04-15 11:53:32');
COMMIT;

-- ----------------------------
-- Table structure for admin_power
-- ----------------------------
DROP TABLE IF EXISTS `admin_power`;
CREATE TABLE `admin_power` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限编号',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限名称',
  `type` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限类型',
  `code` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限标识',
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限路径',
  `open_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '打开方式',
  `parent_id` varchar(19) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父类编号',
  `icon` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `enable` int(11) DEFAULT NULL COMMENT '是否开启',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_power
-- ----------------------------
BEGIN;
INSERT INTO `admin_power` VALUES (1, '系统管理', '0', '', NULL, NULL, '0', 'layui-icon layui-icon-set-fill', 1, NULL, NULL, 1);
INSERT INTO `admin_power` VALUES (3, '用户管理', '1', 'admin:user:main', '/admin/user/', '_iframe', '1', 'layui-icon layui-icon layui-icon layui-icon layui-icon-rate', 1, NULL, NULL, 1);
INSERT INTO `admin_power` VALUES (4, '权限管理', '1', 'admin:power:main', '/admin/power/', '_iframe', '1', NULL, 2, NULL, NULL, 1);
INSERT INTO `admin_power` VALUES (9, '角色管理', '1', 'admin:role:main', '/admin/role', '_iframe', '1', 'layui-icon layui-icon-username', 2, '2021-03-16 22:24:58', '2021-03-25 19:15:24', 1);
INSERT INTO `admin_power` VALUES (12, '系统监控', '1', 'admin:monitor:main', '/admin/monitor', '_iframe', '1', 'layui-icon layui-icon-vercode', 5, '2021-03-18 22:05:19', '2021-03-25 19:15:27', 1);
INSERT INTO `admin_power` VALUES (13, '日志管理', '1', 'admin:log:main', '/admin/log', '_iframe', '1', 'layui-icon layui-icon-read', 4, '2021-03-18 22:37:10', '2021-06-03 11:06:25', 1);
INSERT INTO `admin_power` VALUES (17, '文件管理', '0', '', '', '', '0', 'layui-icon layui-icon-camera', 2, '2021-03-19 18:56:23', '2022-04-05 15:42:54', 1);
INSERT INTO `admin_power` VALUES (18, '图片上传', '1', 'admin:file:main', '/admin/file', '_iframe', '17', 'layui-icon layui-icon-camera', 5, '2021-03-19 18:57:19', '2021-03-25 19:15:13', 1);
INSERT INTO `admin_power` VALUES (21, '权限增加', '2', 'admin:power:add', '', '', '4', 'layui-icon layui-icon-add-circle', 1, '2021-03-22 19:43:52', '2021-03-25 19:15:22', 1);
INSERT INTO `admin_power` VALUES (22, '用户增加', '2', 'admin:user:add', '', '', '3', 'layui-icon layui-icon-add-circle', 1, '2021-03-22 19:45:40', '2021-03-25 19:15:17', 1);
INSERT INTO `admin_power` VALUES (23, '用户编辑', '2', 'admin:user:edit', '', '', '3', 'layui-icon layui-icon-rate', 2, '2021-03-22 19:46:15', '2021-03-25 19:15:18', 1);
INSERT INTO `admin_power` VALUES (24, '用户删除', '2', 'admin:user:remove', '', '', '3', 'layui-icon None', 3, '2021-03-22 19:46:51', '2021-03-25 19:15:18', 1);
INSERT INTO `admin_power` VALUES (25, '权限编辑', '2', 'admin:power:edit', '', '', '4', 'layui-icon layui-icon-edit', 2, '2021-03-22 19:47:36', '2021-03-25 19:15:22', 1);
INSERT INTO `admin_power` VALUES (26, '用户删除', '2', 'admin:power:remove', '', '', '4', 'layui-icon layui-icon-delete', 3, '2021-03-22 19:48:17', '2021-03-25 19:15:23', 1);
INSERT INTO `admin_power` VALUES (27, '用户增加', '2', 'admin:role:add', '', '', '9', 'layui-icon layui-icon-add-circle', 1, '2021-03-22 19:49:09', '2021-03-25 19:15:24', 1);
INSERT INTO `admin_power` VALUES (28, '角色编辑', '2', 'admin:role:edit', '', '', '9', 'layui-icon layui-icon-edit', 2, '2021-03-22 19:49:41', '2021-03-25 19:15:25', 1);
INSERT INTO `admin_power` VALUES (29, '角色删除', '2', 'admin:role:remove', '', '', '9', 'layui-icon layui-icon-delete', 3, '2021-03-22 19:50:15', '2021-03-25 19:15:26', 1);
INSERT INTO `admin_power` VALUES (30, '角色授权', '2', 'admin:role:power', '', '', '9', 'layui-icon layui-icon-component', 4, '2021-03-22 19:50:54', '2021-03-25 19:15:26', 1);
INSERT INTO `admin_power` VALUES (31, '图片增加', '2', 'admin:file:add', '', '', '18', 'layui-icon layui-icon-add-circle', 1, '2021-03-22 19:58:05', '2021-03-25 19:15:28', 1);
INSERT INTO `admin_power` VALUES (32, '图片删除', '2', 'admin:file:delete', '', '', '18', 'layui-icon layui-icon-delete', 2, '2021-03-22 19:58:45', '2021-03-25 19:15:29', 1);
INSERT INTO `admin_power` VALUES (44, '数据字典', '1', 'admin:dict:main', '/admin/dict', '_iframe', '1', 'layui-icon layui-icon-console', 6, '2021-04-16 13:59:49', '2021-04-16 13:59:49', 1);
INSERT INTO `admin_power` VALUES (45, '字典增加', '2', 'admin:dict:add', '', '', '44', 'layui-icon ', 1, '2021-04-16 14:00:59', '2021-04-16 14:00:59', 1);
INSERT INTO `admin_power` VALUES (46, '字典修改', '2', 'admin:dict:edit', '', '', '44', 'layui-icon ', 2, '2021-04-16 14:01:33', '2021-04-16 14:01:33', 1);
INSERT INTO `admin_power` VALUES (47, '字典删除', '2', 'admin:dict:remove', '', '', '44', 'layui-icon ', 3, '2021-04-16 14:02:06', '2021-04-16 14:02:06', 1);
INSERT INTO `admin_power` VALUES (48, '部门管理', '1', 'admin:dept:main', '/dept', '_iframe', '1', 'layui-icon layui-icon-group', 3, '2021-06-01 16:22:11', '2021-07-07 13:49:39', 1);
INSERT INTO `admin_power` VALUES (49, '部门增加', '2', 'admin:dept:add', '', '', '48', 'layui-icon None', 1, '2021-06-01 17:35:52', '2021-06-01 17:36:15', 1);
INSERT INTO `admin_power` VALUES (50, '部门编辑', '2', 'admin:dept:edit', '', '', '48', 'layui-icon ', 2, '2021-06-01 17:36:41', '2021-06-01 17:36:41', 1);
INSERT INTO `admin_power` VALUES (51, '部门删除', '2', 'admin:dept:remove', '', '', '48', 'layui-icon None', 3, '2021-06-01 17:37:15', '2021-06-01 17:37:26', 1);
INSERT INTO `admin_power` VALUES (52, '定时任务', '0', '', '', '', '0', 'layui-icon layui-icon-log', 3, '2021-06-22 21:09:01', '2021-06-22 21:09:01', 1);
INSERT INTO `admin_power` VALUES (53, '任务管理', '1', 'admin:task:main', '/admin/task', '_iframe', '52', 'layui-icon ', 1, '2021-06-22 21:15:00', '2021-06-22 21:15:00', 1);
INSERT INTO `admin_power` VALUES (54, '任务增加', '2', 'admin:task:add', '', '', '53', 'layui-icon ', 1, '2021-06-22 22:20:54', '2021-06-22 22:20:54', 1);
INSERT INTO `admin_power` VALUES (55, '任务修改', '2', 'admin:task:edit', '', '', '53', 'layui-icon ', 2, '2021-06-22 22:21:34', '2021-06-22 22:21:34', 1);
INSERT INTO `admin_power` VALUES (56, '任务删除', '2', 'admin:task:remove', '', '', '53', 'layui-icon ', 3, '2021-06-22 22:22:18', '2021-06-22 22:22:18', 1);
INSERT INTO `admin_power` VALUES (63, '咖啡店单管理', '0', '', '', '', '0', 'layui-icon layui-icon-login-wechat', 4, '2022-03-30 15:07:38', '2022-03-30 15:07:38', 1);
INSERT INTO `admin_power` VALUES (64, '小程序用户管理', '1', '1', '/wxuser/user/', '_iframe', '63', 'layui-icon layui-icon-username', 1, '2022-03-30 15:08:19', '2022-03-30 15:08:19', 1);
INSERT INTO `admin_power` VALUES (65, '商品管理', '1', '1', '/goods/', '_iframe', '63', 'layui-icon layui-icon-release', 2, '2022-03-30 15:09:29', '2022-03-30 15:09:29', 1);
INSERT INTO `admin_power` VALUES (66, '优惠卷管理', '1', '1', '/coupon/', '_iframe', '63', 'layui-icon layui-icon layui-icon-fire', 3, '2022-03-30 15:33:53', '2022-03-30 15:34:12', 1);
INSERT INTO `admin_power` VALUES (67, '店铺管理', '1', '1', '/wxstores/', '_iframe', '63', 'layui-icon layui-icon layui-icon-heart', 5, '2022-03-30 15:37:13', '2022-03-30 17:02:36', 1);
INSERT INTO `admin_power` VALUES (69, '轮播图管理', '1', '1', '/bandas/', '_iframe', '63', 'layui-icon layui-icon layui-icon-key', 6, '2022-03-31 13:11:30', '2022-03-31 13:11:40', 1);
INSERT INTO `admin_power` VALUES (70, '订单管理', '1', '1', '/orders/', '_iframe', '63', 'layui-icon layui-icon layui-icon layui-icon-mute', 7, '2022-03-31 13:46:13', '2022-03-31 14:10:46', 1);
COMMIT;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色标识',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `details` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '详情',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `enable` int(11) DEFAULT NULL COMMENT '是否启用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_role` VALUES (1, '管理员', 'admin', NULL, '管理员', 1, NULL, NULL, 1);
INSERT INTO `admin_role` VALUES (2, '普通用户', 'common', NULL, '只有查看，没有增删改权限2', 2, '2021-03-22 20:02:38', '2022-04-05 15:42:08', 1);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_power
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_power`;
CREATE TABLE `admin_role_power` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `power_id` int(11) DEFAULT NULL COMMENT '用户编号',
  `role_id` int(11) DEFAULT NULL COMMENT '角色编号',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `power_id` (`power_id`) USING BTREE,
  KEY `role_id` (`role_id`) USING BTREE,
  CONSTRAINT `admin_role_power_ibfk_1` FOREIGN KEY (`power_id`) REFERENCES `admin_power` (`id`),
  CONSTRAINT `admin_role_power_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=394 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_role_power
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_power` VALUES (272, 18, 2);
INSERT INTO `admin_role_power` VALUES (335, 3, 1);
INSERT INTO `admin_role_power` VALUES (343, 22, 1);
INSERT INTO `admin_role_power` VALUES (344, 23, 1);
INSERT INTO `admin_role_power` VALUES (345, 24, 1);
INSERT INTO `admin_role_power` VALUES (348, 27, 1);
INSERT INTO `admin_role_power` VALUES (349, 28, 1);
INSERT INTO `admin_role_power` VALUES (350, 29, 1);
INSERT INTO `admin_role_power` VALUES (351, 30, 1);
INSERT INTO `admin_role_power` VALUES (352, 31, 1);
INSERT INTO `admin_role_power` VALUES (353, 32, 1);
INSERT INTO `admin_role_power` VALUES (364, 54, 1);
INSERT INTO `admin_role_power` VALUES (365, 55, 1);
INSERT INTO `admin_role_power` VALUES (366, 56, 1);
INSERT INTO `admin_role_power` VALUES (373, 63, 1);
INSERT INTO `admin_role_power` VALUES (374, 64, 1);
INSERT INTO `admin_role_power` VALUES (375, 65, 1);
INSERT INTO `admin_role_power` VALUES (376, 66, 1);
INSERT INTO `admin_role_power` VALUES (377, 67, 1);
INSERT INTO `admin_role_power` VALUES (379, 69, 1);
INSERT INTO `admin_role_power` VALUES (380, 70, 1);
INSERT INTO `admin_role_power` VALUES (381, 63, 2);
INSERT INTO `admin_role_power` VALUES (382, 64, 2);
INSERT INTO `admin_role_power` VALUES (383, 65, 2);
INSERT INTO `admin_role_power` VALUES (384, 66, 2);
INSERT INTO `admin_role_power` VALUES (385, 67, 2);
INSERT INTO `admin_role_power` VALUES (386, 69, 2);
INSERT INTO `admin_role_power` VALUES (387, 70, 2);
INSERT INTO `admin_role_power` VALUES (388, 3, 2);
INSERT INTO `admin_role_power` VALUES (389, 22, 2);
INSERT INTO `admin_role_power` VALUES (390, 23, 2);
INSERT INTO `admin_role_power` VALUES (391, 24, 2);
INSERT INTO `admin_role_power` VALUES (392, 1, 1);
INSERT INTO `admin_role_power` VALUES (393, 1, 2);
COMMIT;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名',
  `password_hash` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '哈希密码',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '创建时间',
  `enable` int(11) DEFAULT NULL COMMENT '启用',
  `realname` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '真实名字',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '头像',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
BEGIN;
INSERT INTO `admin_user` VALUES (1, 'admin', 'pbkdf2:sha256:260000$sjCmvVDRFrOhHmnS$e0622b98ce71bbd5d6cedbfed8a59d1a93d40632d903deab946ae50b0a7cada8', NULL, '2022-04-15 11:53:49', 1, '超级管理', '要是不能把握时机，就要终身蹭蹬，一事无成！', '/_uploads/photos/1649994811000.jpg', 1);
INSERT INTO `admin_user` VALUES (7, 'test', 'pbkdf2:sha256:150000$cRS8bYNh$adb57e64d929863cf159f924f74d0634f1fecc46dba749f1bfaca03da6d2e3ac', '2021-03-22 20:03:42', '2021-06-01 17:29:47', 1, '超级管理', '要是不能把握时机，就要终身蹭蹬，一事无成', '/static/admin/admin/images/avatar.jpg', 1);
INSERT INTO `admin_user` VALUES (8, 'wind', 'pbkdf2:sha256:150000$skME1obT$6a2c20cd29f89d7d2f21d9e373a7e3445f70ebce3ef1c3a555e42a7d17170b37', '2021-06-01 17:30:39', '2022-04-05 15:42:05', 1, '风', NULL, '/static/admin/admin/images/avatar.jpg', 7);
COMMIT;

-- ----------------------------
-- Table structure for admin_user_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_role`;
CREATE TABLE `admin_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `user_id` int(11) DEFAULT NULL COMMENT '用户编号',
  `role_id` int(11) DEFAULT NULL COMMENT '角色编号',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `role_id` (`role_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  CONSTRAINT `admin_user_role_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`id`),
  CONSTRAINT `admin_user_role_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_user_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_user_role` VALUES (21, 1, 1);
INSERT INTO `admin_user_role` VALUES (22, 7, 2);
INSERT INTO `admin_user_role` VALUES (24, 8, 2);
COMMIT;

-- ----------------------------
-- Table structure for alembic_version
-- ----------------------------
DROP TABLE IF EXISTS `alembic_version`;
CREATE TABLE `alembic_version` (
  `version_num` varchar(32) NOT NULL,
  PRIMARY KEY (`version_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of alembic_version
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bands
-- ----------------------------
DROP TABLE IF EXISTS `bands`;
CREATE TABLE `bands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `photo` varchar(99) DEFAULT NULL,
  `name` varchar(60) DEFAULT NULL,
  `enable` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bands
-- ----------------------------
BEGIN;
INSERT INTO `bands` VALUES (6, 'https://www.lszzsr.top/static/upload/goods/2e4636c5-66fa-443e-aa59-425498e0ab5a.3.webp', '轮播图1', 0);
INSERT INTO `bands` VALUES (7, 'https://www.lszzsr.top/static/upload/goods/2d38c649-d26e-4e5d-bfc1-8c9d7e2675ef.5.webp', '轮播图2', 1);
INSERT INTO `bands` VALUES (8, 'https://www.lszzsr.top/static/upload/goods/155e71bd-da99-4b96-8a97-cf5f1e73d2d2.8.webp', '轮播图3', 1);
INSERT INTO `bands` VALUES (9, 'https://www.lszzsr.top/static/upload/goods/7654faea-07bb-483e-9bfb-36c9e1b330fe.17.webp', '4', 1);
COMMIT;

-- ----------------------------
-- Table structure for goods_remark
-- ----------------------------
DROP TABLE IF EXISTS `goods_remark`;
CREATE TABLE `goods_remark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(60) NOT NULL COMMENT '小程序用户openid',
  `gid` int(11) NOT NULL COMMENT '商品外建',
  `content` varchar(255) DEFAULT NULL COMMENT '评论内容',
  `start` int(11) DEFAULT NULL COMMENT 'start',
  PRIMARY KEY (`id`),
  KEY `openId` (`openid`) USING BTREE,
  KEY `gid` (`gid`),
  CONSTRAINT `goods_remark_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `wx_goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods_remark
-- ----------------------------
BEGIN;
INSERT INTO `goods_remark` VALUES (21, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, '感觉不是很好喝', 4);
INSERT INTO `goods_remark` VALUES (23, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, '好好喝！', 3);
INSERT INTO `goods_remark` VALUES (24, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 25, '好好喝', 4);
COMMIT;

-- ----------------------------
-- Table structure for signtable
-- ----------------------------
DROP TABLE IF EXISTS `signtable`;
CREATE TABLE `signtable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(60) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of signtable
-- ----------------------------
BEGIN;
INSERT INTO `signtable` VALUES (2, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-14 23:42:09', 0);
INSERT INTO `signtable` VALUES (3, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-13 10:07:06', 0);
INSERT INTO `signtable` VALUES (4, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-12 10:10:23', 0);
INSERT INTO `signtable` VALUES (5, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 10:13:25', 0);
INSERT INTO `signtable` VALUES (6, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 12:18:56', 0);
INSERT INTO `signtable` VALUES (7, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 15:36:04', 0);
INSERT INTO `signtable` VALUES (8, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (9, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (10, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (11, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (12, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (13, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (14, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (15, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (16, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (17, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (18, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (19, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-15 17:37:02', 0);
INSERT INTO `signtable` VALUES (20, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-23 10:44:52', 0);
INSERT INTO `signtable` VALUES (21, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (22, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (23, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (24, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (25, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (26, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (27, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (28, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (29, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (30, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (31, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-04-25 19:11:38', 0);
INSERT INTO `signtable` VALUES (32, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (33, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (34, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (35, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (36, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (37, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-03 21:42:00', 0);
INSERT INTO `signtable` VALUES (38, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (39, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (40, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (41, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (42, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (43, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (44, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (45, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-10 12:15:05', 0);
INSERT INTO `signtable` VALUES (46, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2022-05-11 08:21:16', 0);
COMMIT;

-- ----------------------------
-- Table structure for userlevel
-- ----------------------------
DROP TABLE IF EXISTS `userlevel`;
CREATE TABLE `userlevel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(60) DEFAULT NULL COMMENT 'user外建',
  `level` int(11) DEFAULT NULL COMMENT '用户等级',
  `integral` int(11) DEFAULT NULL COMMENT '用户积分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userlevel
-- ----------------------------
BEGIN;
INSERT INTO `userlevel` VALUES (1, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 2, 1630);
INSERT INTO `userlevel` VALUES (2, 'ocmg85A4RAJQ_Xnx7LMcIa5DZbRI', 0, 0);
INSERT INTO `userlevel` VALUES (3, 'ocmg85GQiAw0pcqWQPhbg9csI83I', 0, 9);
INSERT INTO `userlevel` VALUES (4, 'ocmg85PaJq6rhYeO_ORSYUscdfho', 0, 15);
INSERT INTO `userlevel` VALUES (5, 'ocmg85GR33kAUl_V39XtFYAeqmuY', 0, 23);
INSERT INTO `userlevel` VALUES (6, 'ocmg85HZunzZaS9qBc0MacPaRHMA', 0, 13);
COMMIT;

-- ----------------------------
-- Table structure for wx_carts
-- ----------------------------
DROP TABLE IF EXISTS `wx_carts`;
CREATE TABLE `wx_carts` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车id',
  `openid` varchar(60) DEFAULT NULL COMMENT '用户openid',
  `gid` int(11) DEFAULT NULL COMMENT '商品id',
  `good_price` float DEFAULT NULL COMMENT '商品价格',
  `good_gname` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `number` int(11) DEFAULT NULL COMMENT '商品数量',
  `good_photo` varchar(99) DEFAULT NULL COMMENT '商品图片',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_del` int(11) DEFAULT NULL COMMENT '逻辑删除',
  PRIMARY KEY (`id`),
  KEY `gid` (`gid`),
  KEY `openid` (`openid`),
  CONSTRAINT `wx_carts_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `wx_goods` (`id`),
  CONSTRAINT `wx_carts_ibfk_2` FOREIGN KEY (`openid`) REFERENCES `wx_user` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=488 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_carts
-- ----------------------------
BEGIN;
INSERT INTO `wx_carts` VALUES (399, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 11:52:40', 1);
INSERT INTO `wx_carts` VALUES (400, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 6, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 11:52:40', 1);
INSERT INTO `wx_carts` VALUES (401, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 5, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 11:52:40', 1);
INSERT INTO `wx_carts` VALUES (403, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 12:09:25', 1);
INSERT INTO `wx_carts` VALUES (404, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 12:09:25', 1);
INSERT INTO `wx_carts` VALUES (405, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 14:14:24', 1);
INSERT INTO `wx_carts` VALUES (406, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:14:24', 1);
INSERT INTO `wx_carts` VALUES (407, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:14:24', 1);
INSERT INTO `wx_carts` VALUES (408, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:31:08', 1);
INSERT INTO `wx_carts` VALUES (409, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:31:08', 1);
INSERT INTO `wx_carts` VALUES (410, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:31:08', 1);
INSERT INTO `wx_carts` VALUES (411, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 14:37:04', 1);
INSERT INTO `wx_carts` VALUES (412, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (413, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (414, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (415, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (416, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (417, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (418, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (419, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (420, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (421, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (422, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (423, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (424, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (425, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (426, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (427, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (428, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 14:40:17', 1);
INSERT INTO `wx_carts` VALUES (429, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:01:05', 1);
INSERT INTO `wx_carts` VALUES (430, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 15:09:11', 1);
INSERT INTO `wx_carts` VALUES (431, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:09:11', 1);
INSERT INTO `wx_carts` VALUES (432, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (433, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (434, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (435, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (436, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (437, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (438, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (439, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (440, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (441, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (442, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (443, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (444, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (445, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 10, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (446, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (447, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (448, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-15 15:36:04', 1);
INSERT INTO `wx_carts` VALUES (449, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-15 17:37:02', 1);
INSERT INTO `wx_carts` VALUES (450, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-15 17:37:02', 1);
INSERT INTO `wx_carts` VALUES (451, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 3, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-23 10:49:06', 1);
INSERT INTO `wx_carts` VALUES (452, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-23 10:49:06', 1);
INSERT INTO `wx_carts` VALUES (453, 'ocmg85A4RAJQ_Xnx7LMcIa5DZbRI', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-23 14:23:19', 0);
INSERT INTO `wx_carts` VALUES (454, 'ocmg85A4RAJQ_Xnx7LMcIa5DZbRI', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-23 14:23:19', 0);
INSERT INTO `wx_carts` VALUES (455, 'ocmg85A4RAJQ_Xnx7LMcIa5DZbRI', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-23 14:23:19', 0);
INSERT INTO `wx_carts` VALUES (456, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-23 14:23:19', 1);
INSERT INTO `wx_carts` VALUES (457, 'ocmg85GQiAw0pcqWQPhbg9csI83I', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-23 14:23:19', 1);
INSERT INTO `wx_carts` VALUES (458, 'ocmg85PaJq6rhYeO_ORSYUscdfho', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-23 23:02:00', 1);
INSERT INTO `wx_carts` VALUES (459, 'ocmg85PaJq6rhYeO_ORSYUscdfho', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-23 23:02:00', 0);
INSERT INTO `wx_carts` VALUES (460, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 3, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-04-25 19:11:38', 1);
INSERT INTO `wx_carts` VALUES (461, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-04-25 19:11:38', 1);
INSERT INTO `wx_carts` VALUES (462, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-04-25 19:11:38', 1);
INSERT INTO `wx_carts` VALUES (463, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 8, 15, '冰奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '2022-04-25 19:11:38', 1);
INSERT INTO `wx_carts` VALUES (464, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 11, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-03 21:42:00', 1);
INSERT INTO `wx_carts` VALUES (465, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 12, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-03 21:42:00', 1);
INSERT INTO `wx_carts` VALUES (466, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (467, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (468, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 6, 15, '抹茶咖啡', 1, 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (469, 'ocmg85GR33kAUl_V39XtFYAeqmuY', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-05-10 12:15:05', 0);
INSERT INTO `wx_carts` VALUES (470, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 25, 25, '塞壬杯', 1, 'https://www.lszzsr.top/static/upload/goods/1c98ed35-0cf6-42ad-aab6-aa9af70cfd9c.114.png', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (471, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 25, 25, '塞壬杯', 1, 'https://www.lszzsr.top/static/upload/goods/1c98ed35-0cf6-42ad-aab6-aa9af70cfd9c.114.png', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (473, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 26, 10, '鸡蛋卷', 1, 'https://www.lszzsr.top/static/upload/goods/cdd7dad5-8962-4afe-8ab1-6951b4fab103.97.png', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (474, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (475, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (476, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (478, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (479, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 7, 15, '阿白奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (480, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (482, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 9, 17, '摩卡', 3, 'https://www.lszzsr.top/static/upload/goods/d56e9bac-0827-4d04-8836-bf714c8b0cc2.k13.webp', '2022-05-10 12:15:05', 1);
INSERT INTO `wx_carts` VALUES (483, 'ocmg85HZunzZaS9qBc0MacPaRHMA', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-11 10:11:46', 0);
INSERT INTO `wx_carts` VALUES (484, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 3, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-11 10:11:46', 1);
INSERT INTO `wx_carts` VALUES (485, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 5, 12, '浓香奶茶', 1, 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '2022-05-11 10:11:46', 1);
COMMIT;

-- ----------------------------
-- Table structure for wx_classify
-- ----------------------------
DROP TABLE IF EXISTS `wx_classify`;
CREATE TABLE `wx_classify` (
  `classifyid` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类表id',
  `gname` varchar(30) NOT NULL COMMENT '分类名称',
  PRIMARY KEY (`classifyid`),
  UNIQUE KEY `gname` (`gname`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_classify
-- ----------------------------
BEGIN;
INSERT INTO `wx_classify` VALUES (5, '冰杯');
INSERT INTO `wx_classify` VALUES (2, '咖啡');
INSERT INTO `wx_classify` VALUES (1, '奶茶');
INSERT INTO `wx_classify` VALUES (8, '小吃');
INSERT INTO `wx_classify` VALUES (6, '小铁');
INSERT INTO `wx_classify` VALUES (3, '拿铁');
INSERT INTO `wx_classify` VALUES (4, '生椰');
INSERT INTO `wx_classify` VALUES (7, '经典');
COMMIT;

-- ----------------------------
-- Table structure for wx_coupon
-- ----------------------------
DROP TABLE IF EXISTS `wx_coupon`;
CREATE TABLE `wx_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '优惠卷id',
  `coupon_sn` varchar(99) NOT NULL COMMENT '优惠号',
  `coupon_name` varchar(40) DEFAULT NULL COMMENT '优惠卷名称',
  `coupon_type` varchar(40) DEFAULT NULL COMMENT '1，新用户，2普通',
  `minmoney` int(11) DEFAULT NULL COMMENT '多少钱可以使用优惠卷',
  `submoney` int(11) DEFAULT NULL COMMENT '减多少钱',
  `coupon_status` int(11) DEFAULT NULL COMMENT '优惠卷状态',
  `numbers` int(11) DEFAULT NULL COMMENT '优惠卷数量',
  `start_time` datetime DEFAULT NULL COMMENT '优惠卷创建时间',
  `is_del` int(11) DEFAULT NULL COMMENT '逻辑删除',
  `wx_coupon_classifyid` int(11) NOT NULL COMMENT '优惠卷类型外建',
  `end_time` datetime DEFAULT NULL COMMENT '优惠劵有效期',
  `text` varchar(60) DEFAULT NULL COMMENT '状态备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_sn` (`coupon_sn`),
  KEY `wx_coupon_classifyid` (`wx_coupon_classifyid`) USING BTREE,
  CONSTRAINT `123` FOREIGN KEY (`wx_coupon_classifyid`) REFERENCES `wx_coupon_classify` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_coupon
-- ----------------------------
BEGIN;
INSERT INTO `wx_coupon` VALUES (15, 'b12f0c47-b5bb-48d6-b4cb-d8f4e66429e2', '1', '哈哈哈', 1, 2, 0, 1, '2022-03-17 00:00:00', 1, 4, '2022-04-20 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (16, '3273f242-c123-4c1b-9439-e3d34f414f06', '123333', '西休息', 111, 1, 1, 1, '2022-03-10 00:00:00', 1, 5, '2022-04-19 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (17, '56120b30-08f6-4ab5-a99b-f0e22da12cfd', '123', '哈哈哈', 12, 32, 0, 320, '2022-03-10 00:00:00', 1, 4, '2022-04-13 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (18, '6f9fe117-43dc-4f16-9dea-c43288575515', '立减', '西休息', 100, 50, 0, 10, '2022-03-09 00:00:00', 1, 5, '2022-04-15 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (19, '931620e4-ca82-4be8-a03c-2afa7547585c', '1', '西休息', 12, 5, 1, 12, '2022-04-08 00:00:00', 1, 5, '2022-05-18 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (20, '5255e07a-b347-4288-a7dd-8411395fae74', '123', '哈哈哈', 12, 8, 1, 2, '2022-03-31 00:00:00', 0, 4, '2022-05-10 00:00:00', NULL);
INSERT INTO `wx_coupon` VALUES (21, 'fdb8fda2-0c09-4cff-988d-18db68b883e3', '新用户立减', '哈哈哈', 20, 15, 1, 91, '2022-05-11 00:00:00', 0, 4, '2022-06-22 00:00:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for wx_coupon_classify
-- ----------------------------
DROP TABLE IF EXISTS `wx_coupon_classify`;
CREATE TABLE `wx_coupon_classify` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '优惠卷id',
  `name` varchar(30) NOT NULL COMMENT '优惠卷名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE COMMENT '唯一'
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_coupon_classify
-- ----------------------------
BEGIN;
INSERT INTO `wx_coupon_classify` VALUES (7, '哈哈');
INSERT INTO `wx_coupon_classify` VALUES (4, '哈哈哈');
INSERT INTO `wx_coupon_classify` VALUES (5, '西休息');
INSERT INTO `wx_coupon_classify` VALUES (6, '起起起');
COMMIT;

-- ----------------------------
-- Table structure for wx_goods
-- ----------------------------
DROP TABLE IF EXISTS `wx_goods`;
CREATE TABLE `wx_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品表id',
  `price` float NOT NULL COMMENT '商品价格',
  `gname` varchar(35) NOT NULL COMMENT '商品名称',
  `gphoto` varchar(120) NOT NULL COMMENT '商品图片',
  `gnum` varchar(9) NOT NULL COMMENT '商品数量',
  `isdel` int(11) NOT NULL COMMENT '是否删除',
  `is_on_sale` int(11) NOT NULL COMMENT '商品是否上架',
  `unit` varchar(31) DEFAULT NULL COMMENT '商品单位，例如件、盒',
  `content` text COMMENT '商品详细介绍',
  `isnew` int(11) DEFAULT NULL COMMENT '是否是新品',
  `iscommon` int(11) DEFAULT NULL COMMENT '是否是热卖',
  `add_time` datetime DEFAULT NULL COMMENT '商品添加时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `sales` int(11) NOT NULL COMMENT '销量',
  `classifyid` int(11) NOT NULL COMMENT '设置外建',
  PRIMARY KEY (`id`),
  KEY `classifyid` (`classifyid`),
  CONSTRAINT `wx_goods_ibfk_1` FOREIGN KEY (`classifyid`) REFERENCES `wx_classify` (`classifyid`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_goods
-- ----------------------------
BEGIN;
INSERT INTO `wx_goods` VALUES (5, 12, '浓香奶茶', 'https://www.lszzsr.top/static/upload/goods/87ba787e-b99d-4876-a9a6-e67931d2b646.k31.webp', '100', 0, 1, '杯', '', 0, 0, '2022-04-15 11:52:40', NULL, 36, 1);
INSERT INTO `wx_goods` VALUES (6, 15, '抹茶咖啡', 'https://www.lszzsr.top/static/upload/goods/a273ccbd-3040-40db-8a62-e0c26e207091.k24.webp', '89', 0, 1, '杯', '', 1, 1, '2022-04-15 11:52:40', NULL, 14, 3);
INSERT INTO `wx_goods` VALUES (7, 15, '阿白奶茶', 'https://www.lszzsr.top/static/upload/goods/b9d8558d-867d-4dd5-a7d3-9c1d0d7d2929.k21.webp', '90', 0, 1, '杯', '', 1, 1, '2022-04-15 11:52:40', NULL, 14, 1);
INSERT INTO `wx_goods` VALUES (8, 15, '冰奶茶', 'https://www.lszzsr.top/static/upload/goods/0004b1cd-68e8-47fa-85be-cfcd449b376e.k26.webp', '77', 0, 1, '杯', '', 1, 1, '2022-04-15 11:52:40', NULL, 27, 1);
INSERT INTO `wx_goods` VALUES (9, 17, '摩卡', 'https://www.lszzsr.top/static/upload/goods/d56e9bac-0827-4d04-8836-bf714c8b0cc2.k13.webp', '96', 0, 1, '杯', '好喝不腻哈！', 1, 1, '2022-05-10 12:15:05', NULL, 4, 5);
INSERT INTO `wx_goods` VALUES (10, 19, '生椰拿铁', 'https://www.lszzsr.top/static/upload/goods/66f0f40d-b6c6-4383-8833-d6dc8e648e95.k29.webp', '100', 0, 1, '杯', '生椰拿铁，好喝的不行不行的！', 1, 1, '2022-05-10 12:15:05', NULL, 0, 2);
INSERT INTO `wx_goods` VALUES (11, 18, '冰丝绒拿铁', 'https://www.lszzsr.top/static/upload/goods/a5d654db-9bcc-4856-8cac-aed511c27492.k27.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 3);
INSERT INTO `wx_goods` VALUES (12, 22, '耶加', 'https://www.lszzsr.top/static/upload/goods/99e266e6-943a-4af6-97f7-d201984a19dc.k23.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 4);
INSERT INTO `wx_goods` VALUES (13, 19, '耶加拿铁', 'https://www.lszzsr.top/static/upload/goods/5018316a-d289-45c5-9b26-a70f98d7f620.k22.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 3);
INSERT INTO `wx_goods` VALUES (14, 23, '杨枝甘露', 'https://www.lszzsr.top/static/upload/goods/aec76539-15e6-486e-acbb-8114882b728d.k18.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 1);
INSERT INTO `wx_goods` VALUES (15, 17, '抹茶', 'https://www.lszzsr.top/static/upload/goods/3a3cb025-5852-4ebb-a5b4-64a4228ca2eb.k16.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 1);
INSERT INTO `wx_goods` VALUES (16, 17, '陨石拿铁', 'https://www.lszzsr.top/static/upload/goods/fea236c7-6593-43f4-b603-a1f188ef868f.k15.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 3);
INSERT INTO `wx_goods` VALUES (17, 21, '生椰爱摩卡', 'https://www.lszzsr.top/static/upload/goods/0b03e8e2-ebea-424b-84e3-9e68cd6f27d3.k13.webp', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 7);
INSERT INTO `wx_goods` VALUES (18, 15, '柠檬水', 'https://www.lszzsr.top/static/upload/goods/9f0622b1-1b0b-41bc-a7ba-8f95ddf2abf0.125.png', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 7);
INSERT INTO `wx_goods` VALUES (19, 25, '新咖啡', 'https://www.lszzsr.top/static/upload/goods/daa62ebf-87e9-42be-836a-7aa6ac5db765.124.png', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 2);
INSERT INTO `wx_goods` VALUES (20, 25, '乌干达', 'https://www.lszzsr.top/static/upload/goods/651b6dbc-f257-4d24-9267-12ea9d1d8ebd.123.png', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 2);
INSERT INTO `wx_goods` VALUES (21, 15, '黄桃果茶', 'https://www.lszzsr.top/static/upload/goods/57a82c3c-19d6-4ba9-b0cc-02a9b89b1d5b.119.png', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 6);
INSERT INTO `wx_goods` VALUES (22, 20, '精萃科瑞多', 'https://www.lszzsr.top/static/upload/goods/ed168781-7e35-4143-9499-e7bf8c08c4b1.118.png', '100', 0, 1, '杯', '', 1, 1, '2022-05-10 12:15:05', NULL, 0, 7);
INSERT INTO `wx_goods` VALUES (23, 19, '冰咖', 'https://www.lszzsr.top/static/upload/goods/32d125b5-a7af-4154-8c85-d99b0fce85bc.117.png', '100', 0, 1, '杯', '', 1, 0, '2022-05-10 12:15:05', NULL, 0, 5);
INSERT INTO `wx_goods` VALUES (24, 22, '桃桃椰', 'https://www.lszzsr.top/static/upload/goods/99bdd93c-5116-4a8b-a7c3-6bb4b2537461.116.png', '100', 0, 1, '杯', '', 0, 1, '2022-05-10 12:15:05', NULL, 0, 5);
INSERT INTO `wx_goods` VALUES (25, 25, '塞壬杯', 'https://www.lszzsr.top/static/upload/goods/1c98ed35-0cf6-42ad-aab6-aa9af70cfd9c.114.png', '98', 0, 1, '杯', '', 0, 1, '2022-05-10 12:15:05', NULL, 2, 7);
INSERT INTO `wx_goods` VALUES (26, 10, '鸡蛋卷', 'https://www.lszzsr.top/static/upload/goods/cdd7dad5-8962-4afe-8ab1-6951b4fab103.97.png', '98', 0, 1, '杯', '', 0, 1, '2022-05-10 12:15:05', NULL, 2, 8);
COMMIT;

-- ----------------------------
-- Table structure for wx_orders
-- ----------------------------
DROP TABLE IF EXISTS `wx_orders`;
CREATE TABLE `wx_orders` (
  `oid` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单的id',
  `openid` varchar(30) NOT NULL COMMENT '小程序的用户openid',
  `order_sn` varchar(44) NOT NULL COMMENT '订单编号',
  `goodsid` int(11) DEFAULT NULL COMMENT '商品表的外件',
  `redatetime` datetime DEFAULT NULL COMMENT '订单创建时间',
  `pay_type` varchar(4) NOT NULL COMMENT '支付方式',
  `order_price` float NOT NULL COMMENT '订单价格',
  `yuan_price` float NOT NULL COMMENT '支付价格',
  `order_status` int(11) NOT NULL COMMENT '订单状态',
  `pay_status` int(11) NOT NULL COMMENT '支付状态',
  `send_status` int(11) NOT NULL COMMENT '发货状态',
  `send_type` int(11) NOT NULL COMMENT '配送方式0店内，1外卖',
  `send_sn` varchar(40) NOT NULL COMMENT '物流单号',
  `code` varchar(10) NOT NULL COMMENT '取货码',
  `addressid` int(11) DEFAULT NULL COMMENT '收货地址',
  `store` varchar(30) DEFAULT NULL COMMENT '商店民称',
  PRIMARY KEY (`oid`),
  KEY `goodsid` (`goodsid`),
  KEY `openid` (`openid`),
  KEY `order_sn` (`order_sn`),
  CONSTRAINT `wx_orders_ibfk_1` FOREIGN KEY (`goodsid`) REFERENCES `wx_goods` (`id`),
  CONSTRAINT `wx_orders_ibfk_2` FOREIGN KEY (`openid`) REFERENCES `wx_user` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=313 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_orders
-- ----------------------------
BEGIN;
INSERT INTO `wx_orders` VALUES (245, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '0e53e500-86a1-4393-92a8-205e19099645', 5, '2022-04-15 11:52:40', '1', 72, 70, 1, 1, 0, 0, '498661aa-55a9-4f84-8c63-5949ffaf3c79', '8a47', -1, NULL);
INSERT INTO `wx_orders` VALUES (246, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, '2022-04-15 12:09:25', '1', 15, 15, 1, 1, 0, 1, 'fe175a17-5b3d-413b-bfff-6ab16c191409', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (247, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '291be377-5eb2-4bf1-8aff-20ac6932268a', 5, '2022-04-15 12:09:25', '0', 48, 46, 2, 0, 0, 1, '885e0bc5-14a7-45dd-92af-b5e8f4e3ab67', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (248, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, '2022-04-15 12:09:25', '1', 15, 15, 1, 1, 0, 1, 'fe175a17-5b3d-413b-bfff-6ab16c191409', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (249, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '476d01b8-79b4-45c6-987c-45b024f51db5', 8, '2022-04-15 12:09:25', '1', 15, 15, 1, 1, 0, 0, '8bc78b4b-96eb-4fe6-99b5-e44a8d2d5a41', 'b072', -1, NULL);
INSERT INTO `wx_orders` VALUES (250, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '476d01b8-79b4-45c6-987c-45b024f51db5', 8, '2022-04-15 12:09:25', '1', 15, 15, 1, 1, 0, 0, '8bc78b4b-96eb-4fe6-99b5-e44a8d2d5a41', 'b072', -1, NULL);
INSERT INTO `wx_orders` VALUES (251, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '476d01b8-79b4-45c6-987c-45b024f51db5', 8, '2022-04-15 12:09:25', '0', 15, 15, 2, 0, 0, 0, '8bc78b4b-96eb-4fe6-99b5-e44a8d2d5a41', 'b072', -1, NULL);
INSERT INTO `wx_orders` VALUES (252, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, '2022-04-15 12:23:42', '0', 15, 15, 2, 0, 0, 1, 'fe175a17-5b3d-413b-bfff-6ab16c191409', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (253, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, '2022-04-15 14:14:24', '1', 15, 15, 1, 1, 0, 0, '0a05d557-ae4d-45a0-81dd-f8feb7b1fd0f', '7748', -1, NULL);
INSERT INTO `wx_orders` VALUES (254, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, '2022-04-15 14:14:24', '1', 15, 15, 1, 1, 0, 0, '0a05d557-ae4d-45a0-81dd-f8feb7b1fd0f', '7748', -1, NULL);
INSERT INTO `wx_orders` VALUES (255, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, '2022-04-15 14:14:24', '0', 15, 15, 2, 0, 0, 0, '0a05d557-ae4d-45a0-81dd-f8feb7b1fd0f', '7748', -1, NULL);
INSERT INTO `wx_orders` VALUES (256, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '13f84e4f-1a53-4c6c-9e23-6616af24fd06', 7, '2022-04-15 14:14:24', '0', 15, 15, 2, 0, 0, 0, 'b73fcc0f-ac59-4325-b23b-59ff2f730b23', '6997', -1, NULL);
INSERT INTO `wx_orders` VALUES (257, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, '2022-04-15 14:14:24', '1', 15, 15, 1, 1, 0, 0, '9c3510dd-e7eb-4887-8ad0-3233a57fb7b2', 'ff26', -1, NULL);
INSERT INTO `wx_orders` VALUES (258, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, '2022-04-15 14:14:24', '1', 15, 15, 1, 1, 0, 0, '9c3510dd-e7eb-4887-8ad0-3233a57fb7b2', 'ff26', -1, NULL);
INSERT INTO `wx_orders` VALUES (259, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, '2022-04-15 14:31:08', '1', 15, 15, 1, 1, 0, 0, '9c3510dd-e7eb-4887-8ad0-3233a57fb7b2', 'ff26', -1, NULL);
INSERT INTO `wx_orders` VALUES (260, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'b6e639f8-23d9-4cb7-8494-3ca8e2730cd2', 5, '2022-04-15 14:31:08', '1', 27, 25, 1, 1, 0, 0, '577440f5-fb21-4abc-9df8-1c5f95a33c3c', '7ffd', -1, NULL);
INSERT INTO `wx_orders` VALUES (261, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, '2022-04-15 14:31:08', '1', 15, 15, 1, 1, 0, 0, '9c3510dd-e7eb-4887-8ad0-3233a57fb7b2', 'ff26', -1, NULL);
INSERT INTO `wx_orders` VALUES (262, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, '2022-04-15 14:31:08', '0', 15, 15, 2, 0, 0, 0, '9c3510dd-e7eb-4887-8ad0-3233a57fb7b2', 'ff26', -1, NULL);
INSERT INTO `wx_orders` VALUES (263, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '578a291f-0a90-46b6-93e9-ab03025c6552', 5, '2022-04-15 14:31:08', '1', 12, 12, 1, 1, 0, 0, '4eacfc91-5f2e-4332-b5b6-9607b1e72547', '8562', -1, NULL);
INSERT INTO `wx_orders` VALUES (264, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '578a291f-0a90-46b6-93e9-ab03025c6552', 5, '2022-04-15 14:34:45', '0', 12, 12, 2, 0, 0, 0, '4eacfc91-5f2e-4332-b5b6-9607b1e72547', '8562', -1, NULL);
INSERT INTO `wx_orders` VALUES (265, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, '2022-04-15 14:34:45', '1', 15, 15, 1, 1, 0, 0, '9cbae999-0c67-4abe-b862-ac7222d236f4', '8277', -1, NULL);
INSERT INTO `wx_orders` VALUES (266, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, '2022-04-15 14:37:04', '1', 15, 15, 1, 1, 0, 0, '9cbae999-0c67-4abe-b862-ac7222d236f4', '8277', -1, NULL);
INSERT INTO `wx_orders` VALUES (267, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, '2022-04-15 14:37:04', '0', 15, 15, 2, 0, 0, 0, '9cbae999-0c67-4abe-b862-ac7222d236f4', '8277', -1, NULL);
INSERT INTO `wx_orders` VALUES (268, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'a944cff3-ecd2-40a8-8617-ed5c586e3956', 6, '2022-04-15 14:40:17', '1', 15, 15, 1, 1, 0, 0, '5d24cda8-5c3a-40bb-a047-cda404956ac4', '3eff', -1, NULL);
INSERT INTO `wx_orders` VALUES (269, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '6dbcb1a5-b9cb-45d1-81e4-fd5d52716fd3', 6, '2022-04-15 14:40:17', '1', 30, 28, 1, 1, 0, 0, 'f5cbe848-c719-4e52-8b81-1af634fff9c9', '5a61', -1, NULL);
INSERT INTO `wx_orders` VALUES (270, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '000aba9f-dae8-4d71-9d5d-3bee2397148b', 5, '2022-04-15 14:40:17', '0', 27, 25, 2, 0, 0, 0, '2bf3a1f6-1575-46a0-a224-09794b27af1e', '0306', -1, NULL);
INSERT INTO `wx_orders` VALUES (271, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '6fe39830-a561-415b-9e0d-9111b7863873', 5, '2022-04-15 14:40:17', '1', 42, 40, 1, 1, 0, 1, '2d35b9d4-f59e-47c0-a6b4-79971e66b275', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (272, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3a3b4d32-e24e-48d5-8e56-8533c5a7659e', 5, '2022-04-15 14:40:17', '0', 27, 25, 2, 0, 0, 1, '308dbdf7-08d1-4c3b-a4c7-f55bf711b4e6', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (273, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'b1aaa62a-0ebd-4cdc-9332-76e29f90de5d', 7, '2022-04-15 14:40:17', '1', 30, 28, 1, 1, 0, 1, '564cbc23-bf2c-46d1-b2aa-54ff5852f865', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (274, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '19bc1f25-4010-4d5b-86bf-47a351e1f562', 7, '2022-04-15 14:40:17', '1', 30, 28, 1, 1, 0, 0, '37a3ea48-8eeb-4b78-bdea-4ec878773829', '6375', -1, NULL);
INSERT INTO `wx_orders` VALUES (275, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '196c52c3-023b-413e-b09f-3b86422eac42', 5, '2022-04-15 14:40:17', '1', 57, 55, 1, 1, 0, 1, '6f37eeef-65a4-466c-8c20-089577187341', '-1', 12, NULL);
INSERT INTO `wx_orders` VALUES (276, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '272f1667-a2f6-44f9-a1d8-09b6475feff1', 8, '2022-04-15 15:09:11', '0', 15, 15, 2, 0, 0, 0, 'ce22d768-fb3e-40cf-a0ad-9d4f20959fce', '8c3f', -1, '');
INSERT INTO `wx_orders` VALUES (277, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'd06e271f-8b98-4d8e-a93f-45befe9fa9fb', 6, '2022-04-15 15:09:11', '1', 30, 28, 1, 1, 0, 0, '5656025d-3dfe-4b4c-ad13-9993245f16b6', '03eb', -1, '');
INSERT INTO `wx_orders` VALUES (278, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '6ddc0660-40ac-4de3-85d1-376aaa9f386b', 8, '2022-04-15 15:36:04', '1', 15, 15, 1, 1, 0, 1, '170c9201-4623-465f-938d-30191964bae6', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (279, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '815022c5-3026-4a15-89b0-b9499be05567', 6, '2022-04-15 15:36:04', '1', 15, 15, 1, 1, 0, 0, '8dc8a6af-ead8-49a7-9d55-ec269540a683', '449d', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (280, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '1f91c924-8d93-4d42-bebf-30aa55930245', 5, '2022-04-15 15:36:04', '1', 12, 12, 1, 1, 0, 1, 'cf058dca-527d-4e34-bb04-b63fcea8b75c', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (281, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '72a39c63-2304-4d16-8ce1-f611813c255c', 8, '2022-04-15 15:36:04', '1', 30, 28, 1, 1, 0, 0, '3d7bb0ce-84aa-4ffe-970e-c526cb82beea', '9e57', -1, '');
INSERT INTO `wx_orders` VALUES (282, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '93791187-23d0-46e4-828a-4335822b20e5', 5, '2022-04-15 15:36:04', '1', 27, 25, 1, 1, 0, 1, '9d90adb5-75e6-4157-8786-90a39a319232', '-1', 12, '');
INSERT INTO `wx_orders` VALUES (283, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'b8a006b0-585f-46f2-8924-80115afcb2a4', 8, '2022-04-15 15:36:04', '1', 57, 55, 1, 1, 0, 0, '238d8fd2-b55a-4ef7-a4bc-3e0f43b8c04c', '50e4', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (284, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '2e008eb6-a80d-4134-8edd-c823d4a742aa', 8, '2022-04-15 15:36:04', '0', 15, 15, 2, 0, 0, 0, '1e0f3d40-8ce1-4d12-94e7-e9c7221c8612', '79b4', -1, '');
INSERT INTO `wx_orders` VALUES (285, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '1cfb5574-f199-41d1-9446-e99461549b9c', 5, '2022-04-15 15:36:04', '1', 12, 12, 1, 1, 0, 0, 'e455ab73-5f4b-47c7-a8d0-ebaf74992b46', 'b676', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (286, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'b30c6e90-1be9-4ccd-8d08-612f6211cb3d', 8, '2022-04-15 15:36:04', '1', 150, 147, 1, 1, 0, 0, '765f20a0-184b-4d6e-bf77-5ff2c0192e05', '76df', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (287, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '80e2a0a9-e15f-45c3-924c-fa718159c650', 5, '2022-04-15 15:36:04', '1', 12, 12, 1, 1, 0, 0, 'c3657960-b3eb-449b-91dc-85455fa1677a', '8949', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (288, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '7824be52-f22f-4772-acdb-5c7463aeae1b', 6, '2022-04-15 15:36:04', '1', 15, 15, 1, 1, 0, 1, '87c86f97-7405-49f7-a740-9841881c277f', '-1', 13, '华夏店');
INSERT INTO `wx_orders` VALUES (289, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '7bd8f7ea-0702-46f8-bf41-37f848dedb48', 8, '2022-04-15 17:37:02', '1', 15, 15, 1, 1, 0, 0, '46b52a0f-db0f-44ad-8a86-265390937aa8', '5947', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (290, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '90d30145-82f3-4e08-a71f-5ec8835a996d', 7, '2022-04-15 17:37:02', '0', 15, 15, 2, 0, 0, 0, '7739015a-5026-45cf-be6d-b5d3aa64d263', 'e792', -1, '');
INSERT INTO `wx_orders` VALUES (291, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'dcafe52a-5743-426e-8b89-15aa844571db', 5, '2022-04-23 10:49:06', '1', 12, 12, 1, 1, 0, 0, '9788c265-dac5-42a2-9a98-cd0eb1d031e1', 'dda8', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (292, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '967d5a74-d160-45f7-801b-11fcbc67912a', 8, '2022-04-23 10:49:06', '1', 45, 43, 1, 1, 0, 1, '162bb5ea-cc60-49a7-bd4a-75be77aa9717', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (293, 'ocmg85GQiAw0pcqWQPhbg9csI83I', 'accfe75d-b13c-4160-b6d6-29943ebb58b4', 5, '2022-04-23 14:23:19', '0', 12, 12, 0, 1, 0, 0, '5601eb99-dbd7-41dd-811f-335a3b8bba12', '1cc8', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (294, 'ocmg85PaJq6rhYeO_ORSYUscdfho', 'b1d13514-8193-4d03-9af4-6836d4792b97', 5, '2022-04-23 23:02:00', '1', 12, 12, 1, 1, 0, 0, '2477fb5f-49cf-4dda-a59d-3e5c597cbd0a', '3f40', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (295, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'ad069ac7-7d1c-4208-8dde-d85be76b755c', 5, '2022-04-25 19:11:38', '1', 51, 49, 1, 1, 0, 0, '63233f05-4a64-42e5-aa91-1dccd242695a', 'a1c0', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (296, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '15ed9956-a007-4302-a481-2906d39baeaa', 6, '2022-04-25 19:11:38', '1', 15, 15, 1, 1, 0, 1, 'aad2ac22-5f55-413c-bb0c-4f0a65d54f7b', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (297, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '19e84ff7-1a8a-4282-96a6-ecc0af883536', 5, '2022-05-03 21:42:00', '0', 120, 118, 2, 0, 0, 0, 'd6cde04d-91f8-4044-8eda-dadd2e85e6f6', '4103', -1, '');
INSERT INTO `wx_orders` VALUES (298, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'fc6abf0b-52ec-4aae-899c-8857c8938484', 5, '2022-05-03 21:42:00', '1', 132, 130, 1, 1, 0, 0, '2b478f1f-0660-4cc6-a718-914cdf029a59', '431e', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (299, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'f85c022b-fbde-4b7d-817a-1814c8208db5', 5, '2022-05-10 12:15:05', '1', 12, 12, 1, 1, 0, 1, '5f32cce2-4864-4d87-bd00-e0f851b77898', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (300, 'ocmg85GR33kAUl_V39XtFYAeqmuY', '57f03152-d3b1-4941-9478-fbb7630cdb7f', 7, '2022-05-10 12:15:05', '0', 15, 15, 0, 1, 0, 0, '9cba35b0-321e-44a2-8be4-ce1b7e9c1fe7', 'fa86', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (301, 'ocmg85GR33kAUl_V39XtFYAeqmuY', 'a72c73f3-4816-4b96-8e0c-12479d362c6e', 6, '2022-05-10 12:15:05', '0', 15, 15, 0, 1, 0, 0, '781198b2-603f-4791-90d6-9aab1bbce6a4', '38b4', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (302, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'eba4ff89-ec76-470a-8da1-d25e917f1587', 25, '2022-05-10 12:15:05', '1', 25, 23, 1, 1, 0, 0, '5d1f48f9-efcb-4327-b5a6-7ebc2ab751a0', 'a246', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (303, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'e320656d-cbfc-4d3e-bc42-78883e60ac07', 25, '2022-05-10 12:15:05', '1', 25, 23, 1, 1, 0, 1, 'e596bec8-4313-4964-90f3-2a42c52e7358', '-1', 12, '华夏店');
INSERT INTO `wx_orders` VALUES (304, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '6a5a1c82-bf81-42be-81ae-c92964c1287f', 26, '2022-05-10 12:15:05', '1', 10, 10, 1, 1, 0, 0, '005aca98-9522-4d9c-b104-16ee2b3cfb9e', '61bc', -1, '保定店');
INSERT INTO `wx_orders` VALUES (305, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '4243bb43-a17c-43f1-8b14-42190b4d1f51', 26, '2022-05-10 12:15:05', '1', 10, 10, 1, 1, 0, 1, 'c4d157b3-694e-44b9-90bd-0597f843c703', '-1', 12, '保定店');
INSERT INTO `wx_orders` VALUES (306, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'a6c552ac-4a9e-4c5c-8163-fb0f4a03d4a7', 5, '2022-05-10 12:15:05', '0', 12, 12, 2, 0, 0, 1, '46eadb44-ed7f-4f18-8f0d-1263482fd6a1', '-1', 12, '');
INSERT INTO `wx_orders` VALUES (307, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'd39340e1-cdae-4819-8c62-b6e469a985fc', 5, '2022-05-10 12:15:05', '0', 12, 12, 2, 0, 0, 1, 'a4818105-66cd-4330-ad2d-a87a2d42c414', '-1', 12, '');
INSERT INTO `wx_orders` VALUES (308, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '1ec5d3eb-80ed-4595-abbf-639aba7d386c', 7, '2022-05-10 12:15:05', '0', 15, 15, 0, 1, 0, 1, '5af44979-ceb5-4010-a641-ead63e0e377e', '-1', 12, '保定店');
INSERT INTO `wx_orders` VALUES (309, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '978a7335-8b52-4c1e-b886-672dde1773ce', 5, '2022-05-10 12:15:05', '0', 12, 12, 2, 0, 0, 1, 'd35573aa-6454-4486-87af-63e57f8cb9d8', '-1', 12, '');
INSERT INTO `wx_orders` VALUES (310, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '59dc4e7d-5139-4088-a5cf-7f6dbd91db91', 9, '2022-05-10 12:15:05', '1', 51, 49, 1, 1, 0, 0, '28c41f5b-46cd-4c5a-961d-b507e4ffe860', '68c4', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (311, 'ocmg85HZunzZaS9qBc0MacPaRHMA', 'a23d036b-614d-4a94-95f2-8b15e2a88466', 9, '2022-05-11 10:11:46', '0', 17, 17, 0, 1, 0, 0, 'c7a029f2-4b15-43fc-9d7b-7189fbe6587e', '6cae', -1, '华夏店');
INSERT INTO `wx_orders` VALUES (312, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '1ba48dcf-d2d7-4b2b-82cf-64ff7a26d9e2', 5, '2022-05-11 10:11:46', '0', 36, 34, 0, 1, 0, 0, '6103afc0-b2af-4b91-957a-3815b0948e04', 'dd3c', -1, '保定店');
COMMIT;

-- ----------------------------
-- Table structure for wx_orders_item
-- ----------------------------
DROP TABLE IF EXISTS `wx_orders_item`;
CREATE TABLE `wx_orders_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) NOT NULL,
  `goodsid` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_orders_item
-- ----------------------------
BEGIN;
INSERT INTO `wx_orders_item` VALUES (120, '0e53e500-86a1-4393-92a8-205e19099645', 5, 1);
INSERT INTO `wx_orders_item` VALUES (121, '0e53e500-86a1-4393-92a8-205e19099645', 5, 5);
INSERT INTO `wx_orders_item` VALUES (122, 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, 1);
INSERT INTO `wx_orders_item` VALUES (123, '291be377-5eb2-4bf1-8aff-20ac6932268a', 5, 4);
INSERT INTO `wx_orders_item` VALUES (124, 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, 1);
INSERT INTO `wx_orders_item` VALUES (125, '476d01b8-79b4-45c6-987c-45b024f51db5', 8, 1);
INSERT INTO `wx_orders_item` VALUES (126, '476d01b8-79b4-45c6-987c-45b024f51db5', 8, 1);
INSERT INTO `wx_orders_item` VALUES (127, '476d01b8-79b4-45c6-987c-45b024f51db5', 8, 1);
INSERT INTO `wx_orders_item` VALUES (128, 'f9a10045-6996-47c0-8473-dd0e1132facd', 8, 1);
INSERT INTO `wx_orders_item` VALUES (129, 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, 1);
INSERT INTO `wx_orders_item` VALUES (130, 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, 1);
INSERT INTO `wx_orders_item` VALUES (131, 'fc2d6b0e-d1ee-4691-85ef-403297cfce94', 6, 1);
INSERT INTO `wx_orders_item` VALUES (132, '13f84e4f-1a53-4c6c-9e23-6616af24fd06', 7, 1);
INSERT INTO `wx_orders_item` VALUES (133, '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (134, '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (135, '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (136, 'b6e639f8-23d9-4cb7-8494-3ca8e2730cd2', 5, 1);
INSERT INTO `wx_orders_item` VALUES (137, 'b6e639f8-23d9-4cb7-8494-3ca8e2730cd2', 7, 1);
INSERT INTO `wx_orders_item` VALUES (138, '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (139, '3dbab0b3-9894-4dec-80b2-11cbd15e0f3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (140, '578a291f-0a90-46b6-93e9-ab03025c6552', 5, 1);
INSERT INTO `wx_orders_item` VALUES (141, '578a291f-0a90-46b6-93e9-ab03025c6552', 5, 1);
INSERT INTO `wx_orders_item` VALUES (142, '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, 1);
INSERT INTO `wx_orders_item` VALUES (143, '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, 1);
INSERT INTO `wx_orders_item` VALUES (144, '4877c631-096b-444e-89f0-0ccb5e3a541c', 6, 1);
INSERT INTO `wx_orders_item` VALUES (145, 'a944cff3-ecd2-40a8-8617-ed5c586e3956', 6, 1);
INSERT INTO `wx_orders_item` VALUES (146, '6dbcb1a5-b9cb-45d1-81e4-fd5d52716fd3', 6, 1);
INSERT INTO `wx_orders_item` VALUES (147, '6dbcb1a5-b9cb-45d1-81e4-fd5d52716fd3', 8, 1);
INSERT INTO `wx_orders_item` VALUES (148, '000aba9f-dae8-4d71-9d5d-3bee2397148b', 5, 1);
INSERT INTO `wx_orders_item` VALUES (149, '000aba9f-dae8-4d71-9d5d-3bee2397148b', 6, 1);
INSERT INTO `wx_orders_item` VALUES (150, '6fe39830-a561-415b-9e0d-9111b7863873', 5, 1);
INSERT INTO `wx_orders_item` VALUES (151, '6fe39830-a561-415b-9e0d-9111b7863873', 8, 1);
INSERT INTO `wx_orders_item` VALUES (152, '6fe39830-a561-415b-9e0d-9111b7863873', 7, 1);
INSERT INTO `wx_orders_item` VALUES (153, '3a3b4d32-e24e-48d5-8e56-8533c5a7659e', 5, 1);
INSERT INTO `wx_orders_item` VALUES (154, '3a3b4d32-e24e-48d5-8e56-8533c5a7659e', 7, 1);
INSERT INTO `wx_orders_item` VALUES (155, 'b1aaa62a-0ebd-4cdc-9332-76e29f90de5d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (156, 'b1aaa62a-0ebd-4cdc-9332-76e29f90de5d', 8, 1);
INSERT INTO `wx_orders_item` VALUES (157, '19bc1f25-4010-4d5b-86bf-47a351e1f562', 7, 1);
INSERT INTO `wx_orders_item` VALUES (158, '19bc1f25-4010-4d5b-86bf-47a351e1f562', 8, 1);
INSERT INTO `wx_orders_item` VALUES (159, '196c52c3-023b-413e-b09f-3b86422eac42', 5, 1);
INSERT INTO `wx_orders_item` VALUES (160, '196c52c3-023b-413e-b09f-3b86422eac42', 6, 1);
INSERT INTO `wx_orders_item` VALUES (161, '196c52c3-023b-413e-b09f-3b86422eac42', 7, 1);
INSERT INTO `wx_orders_item` VALUES (162, '196c52c3-023b-413e-b09f-3b86422eac42', 8, 1);
INSERT INTO `wx_orders_item` VALUES (163, '272f1667-a2f6-44f9-a1d8-09b6475feff1', 8, 1);
INSERT INTO `wx_orders_item` VALUES (164, 'd06e271f-8b98-4d8e-a93f-45befe9fa9fb', 6, 1);
INSERT INTO `wx_orders_item` VALUES (165, 'd06e271f-8b98-4d8e-a93f-45befe9fa9fb', 8, 1);
INSERT INTO `wx_orders_item` VALUES (166, '6ddc0660-40ac-4de3-85d1-376aaa9f386b', 8, 1);
INSERT INTO `wx_orders_item` VALUES (167, '815022c5-3026-4a15-89b0-b9499be05567', 6, 1);
INSERT INTO `wx_orders_item` VALUES (168, '1f91c924-8d93-4d42-bebf-30aa55930245', 5, 1);
INSERT INTO `wx_orders_item` VALUES (169, '72a39c63-2304-4d16-8ce1-f611813c255c', 8, 1);
INSERT INTO `wx_orders_item` VALUES (170, '72a39c63-2304-4d16-8ce1-f611813c255c', 8, 1);
INSERT INTO `wx_orders_item` VALUES (171, '93791187-23d0-46e4-828a-4335822b20e5', 5, 1);
INSERT INTO `wx_orders_item` VALUES (172, '93791187-23d0-46e4-828a-4335822b20e5', 6, 1);
INSERT INTO `wx_orders_item` VALUES (173, 'b8a006b0-585f-46f2-8924-80115afcb2a4', 8, 1);
INSERT INTO `wx_orders_item` VALUES (174, 'b8a006b0-585f-46f2-8924-80115afcb2a4', 7, 1);
INSERT INTO `wx_orders_item` VALUES (175, 'b8a006b0-585f-46f2-8924-80115afcb2a4', 6, 1);
INSERT INTO `wx_orders_item` VALUES (176, 'b8a006b0-585f-46f2-8924-80115afcb2a4', 5, 1);
INSERT INTO `wx_orders_item` VALUES (177, '2e008eb6-a80d-4134-8edd-c823d4a742aa', 8, 1);
INSERT INTO `wx_orders_item` VALUES (178, '1cfb5574-f199-41d1-9446-e99461549b9c', 5, 1);
INSERT INTO `wx_orders_item` VALUES (179, 'b30c6e90-1be9-4ccd-8d08-612f6211cb3d', 8, 9);
INSERT INTO `wx_orders_item` VALUES (180, 'b30c6e90-1be9-4ccd-8d08-612f6211cb3d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (181, '80e2a0a9-e15f-45c3-924c-fa718159c650', 5, 1);
INSERT INTO `wx_orders_item` VALUES (182, '7824be52-f22f-4772-acdb-5c7463aeae1b', 6, 1);
INSERT INTO `wx_orders_item` VALUES (183, '7bd8f7ea-0702-46f8-bf41-37f848dedb48', 8, 1);
INSERT INTO `wx_orders_item` VALUES (184, '90d30145-82f3-4e08-a71f-5ec8835a996d', 7, 1);
INSERT INTO `wx_orders_item` VALUES (185, 'dcafe52a-5743-426e-8b89-15aa844571db', 5, 1);
INSERT INTO `wx_orders_item` VALUES (186, '967d5a74-d160-45f7-801b-11fcbc67912a', 8, 3);
INSERT INTO `wx_orders_item` VALUES (187, 'accfe75d-b13c-4160-b6d6-29943ebb58b4', 5, 1);
INSERT INTO `wx_orders_item` VALUES (188, 'b1d13514-8193-4d03-9af4-6836d4792b97', 5, 1);
INSERT INTO `wx_orders_item` VALUES (189, 'ad069ac7-7d1c-4208-8dde-d85be76b755c', 5, 3);
INSERT INTO `wx_orders_item` VALUES (190, 'ad069ac7-7d1c-4208-8dde-d85be76b755c', 7, 1);
INSERT INTO `wx_orders_item` VALUES (191, '15ed9956-a007-4302-a481-2906d39baeaa', 6, 1);
INSERT INTO `wx_orders_item` VALUES (192, '19e84ff7-1a8a-4282-96a6-ecc0af883536', 5, 10);
INSERT INTO `wx_orders_item` VALUES (193, 'fc6abf0b-52ec-4aae-899c-8857c8938484', 5, 11);
INSERT INTO `wx_orders_item` VALUES (194, 'f85c022b-fbde-4b7d-817a-1814c8208db5', 5, 1);
INSERT INTO `wx_orders_item` VALUES (195, '57f03152-d3b1-4941-9478-fbb7630cdb7f', 7, 1);
INSERT INTO `wx_orders_item` VALUES (196, 'a72c73f3-4816-4b96-8e0c-12479d362c6e', 6, 1);
INSERT INTO `wx_orders_item` VALUES (197, 'eba4ff89-ec76-470a-8da1-d25e917f1587', 25, 1);
INSERT INTO `wx_orders_item` VALUES (198, 'e320656d-cbfc-4d3e-bc42-78883e60ac07', 25, 1);
INSERT INTO `wx_orders_item` VALUES (199, '6a5a1c82-bf81-42be-81ae-c92964c1287f', 26, 1);
INSERT INTO `wx_orders_item` VALUES (200, '4243bb43-a17c-43f1-8b14-42190b4d1f51', 26, 1);
INSERT INTO `wx_orders_item` VALUES (201, 'a6c552ac-4a9e-4c5c-8163-fb0f4a03d4a7', 5, 1);
INSERT INTO `wx_orders_item` VALUES (202, 'd39340e1-cdae-4819-8c62-b6e469a985fc', 5, 1);
INSERT INTO `wx_orders_item` VALUES (203, '1ec5d3eb-80ed-4595-abbf-639aba7d386c', 7, 1);
INSERT INTO `wx_orders_item` VALUES (204, '978a7335-8b52-4c1e-b886-672dde1773ce', 5, 1);
INSERT INTO `wx_orders_item` VALUES (205, '59dc4e7d-5139-4088-a5cf-7f6dbd91db91', 9, 3);
INSERT INTO `wx_orders_item` VALUES (206, 'a23d036b-614d-4a94-95f2-8b15e2a88466', 9, 1);
INSERT INTO `wx_orders_item` VALUES (207, '1ba48dcf-d2d7-4b2b-82cf-64ff7a26d9e2', 5, 3);
COMMIT;

-- ----------------------------
-- Table structure for wx_store
-- ----------------------------
DROP TABLE IF EXISTS `wx_store`;
CREATE TABLE `wx_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商家id',
  `iconPath` varchar(99) DEFAULT NULL COMMENT '商家图标',
  `latitude` varchar(10) DEFAULT NULL COMMENT '纬度',
  `longitude` varchar(10) DEFAULT NULL COMMENT '经度',
  `title` varchar(30) DEFAULT NULL COMMENT '店家名称',
  `content` varchar(99) DEFAULT NULL COMMENT '店家介绍',
  `slogan` varchar(99) DEFAULT NULL COMMENT '店家标语',
  `enable` int(11) DEFAULT '1',
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_del` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_store
-- ----------------------------
BEGIN;
INSERT INTO `wx_store` VALUES (10, '', '39.987715', '116.288309', '', '好喝', '爽', 1, '2022-04-14 23:47:36', NULL, 1);
INSERT INTO `wx_store` VALUES (11, '', '39.988109', '116.287281', '', '12', '12', 1, '2022-04-15 00:01:14', NULL, 1);
INSERT INTO `wx_store` VALUES (12, '', '39.988109', '116.287281', '111', '1', '1', 1, '2022-04-15 00:01:14', NULL, 1);
INSERT INTO `wx_store` VALUES (13, '', '39.988109', '116.287281', '华夏店', '好喝', '真好喝', 1, '2022-04-15 00:01:14', NULL, 0);
INSERT INTO `wx_store` VALUES (14, '', '38.853578', '115.492462', '保定店', '好喝就完事儿', '喝就完事儿', 1, '2022-05-10 12:15:05', NULL, 0);
INSERT INTO `wx_store` VALUES (15, '', '28.258258', '112.897620', '长沙店', '喝它', '不喝它你喝啥', 1, '2022-05-10 12:15:05', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for wx_user
-- ----------------------------
DROP TABLE IF EXISTS `wx_user`;
CREATE TABLE `wx_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(20) NOT NULL COMMENT '小程序用户名',
  `openid` varchar(60) NOT NULL COMMENT '小程序用户openid',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `password_hash` varchar(128) DEFAULT NULL COMMENT '哈希密码',
  `enable` int(11) DEFAULT NULL COMMENT '启用',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `level` int(11) DEFAULT '0' COMMENT '用户等级',
  `integral` int(11) DEFAULT '0' COMMENT '用户积分',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `openid` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_user
-- ----------------------------
BEGIN;
INSERT INTO `wx_user` VALUES (2, 'maddog', 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKD6bl87Ug3emgARCJ2ic7PpqqVLcYDqdpfxMDSmcFXy9FlR9vmib8Rjhhiab5b3566mXRfHpVM3nsWQ/132', NULL, NULL, 'pbkdf2:sha256:260000$gSpSEV4w5vD7A2C9$142bed92528c18204783378aba96983e4dc378a7405f78a0c5ad17fd079d705e', 1, '2022-04-14 10:12:59', '2022-05-11 11:37:48', 2, 1630);
INSERT INTO `wx_user` VALUES (3, 'DODO', 'ocmg85A4RAJQ_Xnx7LMcIa5DZbRI', 'https://thirdwx.qlogo.cn/mmopen/vi_32/J9rtcyAmX7icjsic9ZPLps53rfAYB4QR3JFWs89hRadAticIicqXhqgUKmTfibRQyx07PDGnpKjvq6rRS3q7EVU3I4A/132', NULL, NULL, 'pbkdf2:sha256:260000$COdJzzYxiR96fGWs$5b25f5a42c664db8c6d19091a4094d66eca04ceedad2db7d49e4521aad221faf', 1, '2022-04-23 14:27:58', '2022-04-23 14:27:58', 0, 0);
INSERT INTO `wx_user` VALUES (4, '光', 'ocmg85GQiAw0pcqWQPhbg9csI83I', 'https://thirdwx.qlogo.cn/mmopen/vi_32/UsavciapkMHk0xbolHIx50ThIk2oaP8kxuF7ZK66j0YtLv52jAHSmUQv7aV8YKdBWOUsvYkEBp7r1KLuHl9WFNQ/132', NULL, NULL, 'pbkdf2:sha256:260000$fQwxCYRHb7vv5poI$68e3cd88e2178d829eec1b6bbc213ccf39c21177ff4ea5ff36da636c2c01c155', 1, '2022-04-23 17:22:36', '2022-04-23 17:23:00', 0, 9);
INSERT INTO `wx_user` VALUES (5, 'Casper', 'ocmg85PaJq6rhYeO_ORSYUscdfho', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJCsXpUUw1PObB3LkLPZjeGrr549Wy01Rb0uic24M3lwCV7746exXzGucLE0G5tApH6ZwT67lefrSw/132', NULL, NULL, 'pbkdf2:sha256:260000$mF1EQ6751SMOZO6M$66b5c6b33c1246a2a39625aaadd866dc6ee8e8bfa6a6cfc961356c4aca020e26', 1, '2022-04-23 23:02:18', '2022-04-23 23:02:51', 0, 15);
INSERT INTO `wx_user` VALUES (6, 'Pudding', 'ocmg85GR33kAUl_V39XtFYAeqmuY', 'https://thirdwx.qlogo.cn/mmopen/vi_32/ViaibXUiaUN9KWnSRf1sOxuP8NJ6Ddn8SlQMpiaOiaeYpH47YUEwJTX2coZHodhC8sic4qLRLKI3GAzVx48FX85jWb8w/132', NULL, NULL, 'pbkdf2:sha256:260000$ZT5qyvy2EoXmI5qh$50df2411e1531b45b72865b586155ee6fecb7029f7e1ca16976fe43cf73823d8', 1, '2022-05-10 12:26:49', '2022-05-10 12:31:42', 0, 23);
INSERT INTO `wx_user` VALUES (7, '旺旺', 'ocmg85HZunzZaS9qBc0MacPaRHMA', 'https://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epE9GEPGn7OoDIvmCQzr1thqFlzJn0Mrvwsd74dkibqQtxVeGxmhibEm1PibIaT6jGOjB4iaEAVRjicuoA/132', NULL, NULL, 'pbkdf2:sha256:260000$dgJ5DJ8u1fAXjzO8$ce0c9afc4ca968017e7510c505ec8f69259b09cdf31e99b25e98c56f6a10c969', 1, '2022-05-11 11:35:33', '2022-05-11 11:36:47', 0, 13);
COMMIT;

-- ----------------------------
-- Table structure for wx_user_address
-- ----------------------------
DROP TABLE IF EXISTS `wx_user_address`;
CREATE TABLE `wx_user_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `openid` varchar(60) NOT NULL COMMENT '设置外建',
  `username` varchar(20) DEFAULT NULL COMMENT '收货地址的用户名',
  `address` varchar(90) DEFAULT NULL COMMENT '收货地址',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `default` int(11) DEFAULT NULL COMMENT '是否设置维默认地址，1是默认',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `openid` (`openid`),
  CONSTRAINT `wx_user_address_ibfk_1` FOREIGN KEY (`openid`) REFERENCES `wx_user` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_user_address
-- ----------------------------
BEGIN;
INSERT INTO `wx_user_address` VALUES (12, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '流水账', '河北省秦皇岛市海港区哈哈哈', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKD6bl87Ug3emgARCJ2ic7PpqqVLcYDqdpfxMDSmcFXy9FlR9vmib8Rjhhiab5b3566mXRfHpVM3nsWQ/132', '15623577604', 1, '2022-04-14 21:34:50', '2022-04-14 21:34:50');
INSERT INTO `wx_user_address` VALUES (13, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '流水账', '河北省秦皇岛市海港区1栋18号', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKD6bl87Ug3emgARCJ2ic7PpqqVLcYDqdpfxMDSmcFXy9FlR9vmib8Rjhhiab5b3566mXRfHpVM3nsWQ/132', '15623577689', 1, '2022-04-15 16:23:37', '2022-04-15 16:23:37');
COMMIT;

-- ----------------------------
-- Table structure for wx_user_coupon
-- ----------------------------
DROP TABLE IF EXISTS `wx_user_coupon`;
CREATE TABLE `wx_user_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(30) NOT NULL COMMENT '用户的外建',
  `coupon_sn` varchar(99) NOT NULL COMMENT '优惠卷编号',
  `status` int(11) DEFAULT NULL COMMENT '优惠卷状态，0可用，1已使用，2过期',
  `add_time` datetime DEFAULT NULL COMMENT '领取优惠卷的时间',
  PRIMARY KEY (`id`),
  KEY `coupon_sn` (`coupon_sn`),
  KEY `openid` (`openid`),
  CONSTRAINT `wx_user_coupon_ibfk_1` FOREIGN KEY (`coupon_sn`) REFERENCES `wx_coupon` (`coupon_sn`),
  CONSTRAINT `wx_user_coupon_ibfk_2` FOREIGN KEY (`openid`) REFERENCES `wx_user` (`openid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wx_user_coupon
-- ----------------------------
BEGIN;
INSERT INTO `wx_user_coupon` VALUES (6, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', '3273f242-c123-4c1b-9439-e3d34f414f06', 1, '2022-04-14 19:10:11');
INSERT INTO `wx_user_coupon` VALUES (7, 'ocmg85GQiAw0pcqWQPhbg9csI83I', '3273f242-c123-4c1b-9439-e3d34f414f06', 0, '2022-04-23 14:23:19');
INSERT INTO `wx_user_coupon` VALUES (8, 'ocmg85A_-Bf-Gg_qkXthHHAXkqww', 'fdb8fda2-0c09-4cff-988d-18db68b883e3', 0, '2022-05-10 12:15:05');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
